🕷️️ Job Radar • SCRAPING

upwork.com 🟡 2026-05-14

🔹 Convert manual Excel-based data validation workflow into Python tool
👤 Client: 🇮🇳 India Member since 2026-05-13
💰 Price: ****
🚩 Problem: Manual execution of data validation and reconciliation in Excel is error-prone and time-consuming.
📦 Existing: Current workbook using VLOOKUP, XLOOKUP, IF formulas for validation; sample file available.

Specifications:

[Target] Convert existing Excel logic to Python code
[Method] Use pandas for data manipulation and openpyxl for output
[UI/UX] No UI required; focus on robust error handling and clear output in Excel
[Stack] Python, pandas, openpyxl, possibly PyV8 for VLOOKUP-like functionality
[Security] Ensure data privacy with secure file handling
[Format] Output polished Excel workbook with validation results

Workflow:

Import source-of-truth and external system datasets using pandas.
Perform lookups and comparisons in Python, replicating existing logic.
Flag matches and mismatches based on phone numbers and locations.
Populate the output Excel workbook with validation results.